RE: [SQL] Getting datatype before SELECT

At 18:41 +0200 on 1/10/98, Jackson, DeJuan wrote:


> > The approach is to work on your query, and replace its where clause
> > (or add one if it doesn't have one) with boolean literal 'false'.

> How does this work with joins?

Sorry, I was on vacation...

Shouldn't make any difference. You don't *have* to restrict a join. It
certainly doesn't matter, where the types and lengths of the fields are
important, what the conditions of the join are. Just mention all the table
names. The cartesian product will not be performed, because the condition
is false. Only the types and lengths will be calculated for you.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma